rem *******************************Code Start*****************************
@echo off

set "Ymd=%date:~,4%%date:~5,2%%date:~8,2%"
C:\phpStudy\MySQL\bin\mysqldump -uroot -proot dbname>C:\autodumpmysql\mysql_%Ymd%.sql
@echo on
rem *******************************Code End*****************************